﻿CREATE VIEW [dbo].[analysis_GetActiveUsersRoleAndType]
AS
SELECT     TOP (100) PERCENT dbo.Users.UserID, dbo.Users.UserName, dbo.Users.FullName, dbo.Users.RoleID, dbo.Roles.Name, dbo.Users.UserTypeID, 
                      dbo.UserType.TypeName
FROM         dbo.Roles INNER JOIN
                      dbo.Users ON dbo.Roles.RoleID = dbo.Users.RoleID INNER JOIN
                      dbo.UserType ON dbo.Users.UserTypeID = dbo.UserType.UserTypeID
WHERE     (dbo.Users.IsActive = 1)
ORDER BY dbo.Users.UserID;

